---
title: WorksheetFunction.RandBetween Method (Excel)
keywords: vbaxl10.chm137340
f1_keywords:
- vbaxl10.chm137340
ms.prod: excel
api_name:
- Excel.WorksheetFunction.RandBetween
ms.assetid: 0b55c6d6-bfb4-a1e3-d37e-afb3ab90dc70
ms.date: 06/08/2017
---


# WorksheetFunction.RandBetween Method (Excel)

Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.


## Syntax

 _expression_ . **RandBetween**( **_Arg1_** , **_Arg2_** )

 _expression_ A variable that represents a **WorksheetFunction** object.


### Parameters



|**Name**|**Required/Optional**|**Data Type**|**Description**|
|:-----|:-----|:-----|:-----|
| _Arg1_|Required| **Variant**|Bottom - the smallest integer RANDBETWEEN will return.|
| _Arg2_|Required| **Variant**|Top - the largest integer RANDBETWEEN will return.|

### Return Value

Double


## See also


#### Concepts


[WorksheetFunction Object](worksheetfunction-object-excel.md)

